package com.ctshk.rpc.goods.mapper;

import com.ctshk.rpc.goods.base.CustomBaseMapper;
import com.ctshk.rpc.goods.entity.ShoppingSpecialCommodity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 专题商品 Mapper 接口
 * </p>
 *
 * @author 姜斌文
 * @since 2021-04-30
 */
public interface ShoppingSpecialCommodityMapper extends CustomBaseMapper<ShoppingSpecialCommodity> {

    @Select("select t.id,t.special_id,t.commodity_id,t.sort,t.gmt_create,t.create_id,t.gmt_modified,t.modified_id,t.is_deleted " +
            "from t_shopping_special_commodity t " +
            "where t.is_deleted = 0 and t.special_id = #{specialId}")
    List<ShoppingSpecialCommodity> findShoppingSpecialCommodityBySpecialId(@Param("specialId") Long specialId);
}
